using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using DgvFilterPopup;

namespace <Application>.<Presentation>
{
    public partial class frm<OwnerU>_<TableU> : Form
    {
        public frm<OwnerU>_<TableU>()
        {
            InitializeComponent();
        }

        <Database>DataClass cls<Database>Data = new <Database>DataClass();
        <OwnerU>_<TableU>DataClass cls<OwnerU>_<TableU>Data = new <OwnerU>_<TableU>DataClass();
        bool dirty;

        private void frm<OwnerU>_<TableU>_Load(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            dirty = false;
            LoadGridCode();
            DgvFilterManager filterManager = new DgvFilterManager(gridCode);
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void frm<OwnerU>_<TableU>_FormClosing(object sender, FormClosingEventArgs e)
        {
            if (dirty == true)
            {
                DialogResult result = MessageBox.Show("Save Changes?", "Save", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
                if (result == System.Windows.Forms.DialogResult.Yes)
                {
                    bSave.PerformClick();
                }
                else
                {
                    MessageBox.Show("Changes NOT saved.", "Error", MessageBoxButtons.OK);
                    dirty = false;
                }
            }
        }

        private void LoadGridCode()
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            try
            { 
                gridCode.DataSource = <OwnerU>_<TableU>DataClass.Open();
        	<If Loop>
	          <IsPKey>
                gridCode.Columns[<ColNo>].DefaultCellStyle.BackColor = Color.LightGray;
        	</If Loop>
        	<If Loop>
	          <IsNotPKey>
	          <And>
	          <IsIdentity>
                gridCode.Columns[<ColNo>].DefaultCellStyle.BackColor = Color.LightGray;
        	</If Loop>
        	<If Loop>
	          <IsNotIdentityCount>
	          <And>
	          <IsNotPKeyCount>
                gridCode.Columns[<ColNo>].DefaultCellStyle.BackColor = Color.LightGray;
	          <ExitLoop>
        	</If Loop>
        	<If Loop>
	          <IsIdentity>
                gridCode.Columns[<ColNo>].ReadOnly = true;
	          <IsMoney>
                gridCode.Columns[<ColNo>].DefaultCellStyle.Format = "c";
		  <IsSmallMoney>
                gridCode.Columns[<ColNo>].DefaultCellStyle.Format = "c";
                  <IsNumber>
                  <And>
                  <IsNotFKey>
                gridCode.Columns[<ColNo>].DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleRight;
        	</If Loop>
        	<If Loop>
                  <IsFKey>
                Load<FieldU>_ComboBox(gridCode);
        	</If Loop>
        	<If Loop>
                  <IsDateTimePicker>
                Load<FieldU>_DateTimePicker(gridCode);
        	</If Loop>
            }
            catch { }
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        <If Loop>
        <IsFKey>
        private void Load<FieldU>_ComboBox(DataGridView grid)
        {
            try
                {
                    List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>> <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = new  List<<OwnerU>_<TableU>_<ROwnerU>_<RTableU>Class<MiscTag>>();
                    <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List = <OwnerU>_<TableU>_<ROwnerU>_<RTableU>DataClass<MiscTag>.List();
                    <IsFKey>
                    DataGridViewComboBoxColumn col = new DataGridViewComboBoxColumn();
                    col.HeaderText = "<FieldC>";
                    col.DataSource = <OwnerU>_<TableU>_<ROwnerU>_<RTableU>List;
                    col.DataPropertyName = "<FieldC>";
                    col.ValueMember = "<RFieldU>";
                    col.DisplayMember = "<RDisplayFieldU>";
                    grid.Columns.RemoveAt(<ColNo>);
                    grid.Columns.Insert(<ColNo>, col);
                }
            catch (Exception ex)
                {
                     MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }

        </If Loop>
        <If Loop>
        <IsDateTimePicker>
        private void Load<FieldU>_DateTimePicker(DataGridView grid)
        {
            try
            {
                CalendarColumn col = new CalendarColumn();
                col.HeaderText = "<FieldC>";
                col.DataPropertyName = "<FieldC>";
                grid.Columns.RemoveAt(<ColNo>);
                grid.Columns.Insert(<ColNo>, col);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, ex.GetType().ToString());
            }
        }

        </If Loop>
        private void gridCode_CellEndEdit(object sender, DataGridViewCellEventArgs e)
        {
            dirty = true;
        }
        
        private void bSave_Click(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            cls<OwnerU>_<TableU>Data.Save(gridCode);
            dirty = false;
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void bDelete_Click(object sender, EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            DialogResult result = MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                gridCode.Rows.RemoveAt(gridCode.CurrentRow.Index);
            }
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void gridCode_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            DialogResult result = MessageBox.Show("Are you sure? Delete this record?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
            if (result == DialogResult.Yes)
            {
                e.Cancel = false;
            }
            else
            {
                e.Cancel = true;
            }
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void bCancel_Click(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            dirty = false;
            LoadGridCode();
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void bWord_Click(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            cls<Database>Data.ExportToWord("Many", this.Text, gridCode);
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void bExcel_Click(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            cls<Database>Data.ExportToExcel("Many", this.Text, gridCode);
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

        private void bPDF_Click(object sender, System.EventArgs e)
        {
            this.Cursor = System.Windows.Forms.Cursors.WaitCursor;
            cls<Database>Data.ExportToPDF("Many", this.Text, gridCode, gridCode.CurrentRow);
            this.Cursor = System.Windows.Forms.Cursors.Default;
        }

    }
}
